﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DSGetPeriodoAula" targetNamespace="http://tempuri.org/DSGetPeriodoAula.xsd" xmlns:mstns="http://tempuri.org/DSGetPeriodoAula.xsd" xmlns="http://tempuri.org/DSGetPeriodoAula.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="DBMatriculaConnectionString4" IsAppSettingsProperty="true" Modifier="Assembly" Name="DBMatriculaConnectionString4 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WindowsApplication1.My.MySettings.GlobalReference.Default.DBMatriculaConnectionString4" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="DBMatriculaConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DBMatriculaConnectionString1 (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WindowsApplication1.My.MySettings.GlobalReference.Default.DBMatriculaConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SPGetPeriodoAulaTableAdapter" GeneratorDataComponentClassName="SPGetPeriodoAulaTableAdapter" Name="SPGetPeriodoAula" UserDataComponentName="SPGetPeriodoAulaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DBMatriculaConnectionString1 (MySettings)" DbObjectName="DBMatricula.dbo.SPGetPeriodoAula" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SPGetPeriodoAula</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAluno" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDEspecifica" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDEspecifica" DataSetColumn="IDEspecifica" />
              <Mapping SourceColumn="DEEspecifica" DataSetColumn="DEEspecifica" />
              <Mapping SourceColumn="DTPedidoCancelamento" DataSetColumn="DTPedidoCancelamento" />
              <Mapping SourceColumn="DTInicioAula" DataSetColumn="DTInicioAula" />
              <Mapping SourceColumn="DTFimAula" DataSetColumn="DTFimAula" />
              <Mapping SourceColumn="PeriodoContrato" DataSetColumn="PeriodoContrato" />
              <Mapping SourceColumn="PeriodoAula" DataSetColumn="PeriodoAula" />
              <Mapping SourceColumn="ValorContratual" DataSetColumn="ValorContratual" />
              <Mapping SourceColumn="VLPeriodoAula" DataSetColumn="VLPeriodoAula" />
              <Mapping SourceColumn="VLCancelamento" DataSetColumn="VLCancelamento" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DSGetPeriodoAula" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DSGetPeriodoAula" msprop:Generator_UserDSName="DSGetPeriodoAula">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SPGetPeriodoAula" msprop:Generator_TableClassName="SPGetPeriodoAulaDataTable" msprop:Generator_TableVarName="tableSPGetPeriodoAula" msprop:Generator_TablePropName="SPGetPeriodoAula" msprop:Generator_RowDeletingName="SPGetPeriodoAulaRowDeleting" msprop:Generator_UserTableName="SPGetPeriodoAula" msprop:Generator_RowChangingName="SPGetPeriodoAulaRowChanging" msprop:Generator_RowEvHandlerName="SPGetPeriodoAulaRowChangeEventHandler" msprop:Generator_RowDeletedName="SPGetPeriodoAulaRowDeleted" msprop:Generator_RowEvArgName="SPGetPeriodoAulaRowChangeEvent" msprop:Generator_RowChangedName="SPGetPeriodoAulaRowChanged" msprop:Generator_RowClassName="SPGetPeriodoAulaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDEspecifica" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnIDEspecifica" msprop:Generator_ColumnPropNameInRow="IDEspecifica" msprop:Generator_ColumnPropNameInTable="IDEspecificaColumn" msprop:Generator_UserColumnName="IDEspecifica" type="xs:int" />
              <xs:element name="DEEspecifica" msprop:Generator_ColumnVarNameInTable="columnDEEspecifica" msprop:Generator_ColumnPropNameInRow="DEEspecifica" msprop:Generator_ColumnPropNameInTable="DEEspecificaColumn" msprop:Generator_UserColumnName="DEEspecifica">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTPedidoCancelamento" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnDTPedidoCancelamento" msprop:Generator_ColumnPropNameInRow="DTPedidoCancelamento" msprop:Generator_ColumnPropNameInTable="DTPedidoCancelamentoColumn" msprop:Generator_UserColumnName="DTPedidoCancelamento" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DTInicioAula" msprop:Generator_ColumnVarNameInTable="columnDTInicioAula" msprop:Generator_ColumnPropNameInRow="DTInicioAula" msprop:Generator_ColumnPropNameInTable="DTInicioAulaColumn" msprop:Generator_UserColumnName="DTInicioAula" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DTFimAula" msprop:Generator_ColumnVarNameInTable="columnDTFimAula" msprop:Generator_ColumnPropNameInRow="DTFimAula" msprop:Generator_ColumnPropNameInTable="DTFimAulaColumn" msprop:Generator_UserColumnName="DTFimAula" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PeriodoContrato" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPeriodoContrato" msprop:Generator_ColumnPropNameInRow="PeriodoContrato" msprop:Generator_ColumnPropNameInTable="PeriodoContratoColumn" msprop:Generator_UserColumnName="PeriodoContrato" type="xs:decimal" minOccurs="0" />
              <xs:element name="PeriodoAula" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnPeriodoAula" msprop:Generator_ColumnPropNameInRow="PeriodoAula" msprop:Generator_ColumnPropNameInTable="PeriodoAulaColumn" msprop:Generator_UserColumnName="PeriodoAula" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValorContratual" msprop:Generator_ColumnVarNameInTable="columnValorContratual" msprop:Generator_ColumnPropNameInRow="ValorContratual" msprop:Generator_ColumnPropNameInTable="ValorContratualColumn" msprop:Generator_UserColumnName="ValorContratual" type="xs:decimal" />
              <xs:element name="VLPeriodoAula" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVLPeriodoAula" msprop:Generator_ColumnPropNameInRow="VLPeriodoAula" msprop:Generator_ColumnPropNameInTable="VLPeriodoAulaColumn" msprop:Generator_UserColumnName="VLPeriodoAula" type="xs:decimal" minOccurs="0" />
              <xs:element name="VLCancelamento" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnVLCancelamento" msprop:Generator_ColumnPropNameInRow="VLCancelamento" msprop:Generator_ColumnPropNameInTable="VLCancelamentoColumn" msprop:Generator_UserColumnName="VLCancelamento" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SPGetPeriodoAula" />
      <xs:field xpath="mstns:IDEspecifica" />
    </xs:unique>
  </xs:element>
</xs:schema>